Tabela WaitListItemHistory

Definicja tabeli WaitListItemHistory

Name

WaitListItemHistory

Code

WaitListItemHistory

Comment

 


Lista kolumn tabeli WaitListItemHistory

Name

Code

WaitListItemHistoryID

WaitListItemHistoryID

WaitingListItemID

WaitingListItemID

StatusID

StatusID

ExpectedAdmissionDT

ExpectedAdmissionDT

ExpectedAdmissionDtPrecision

ExpectedAdmissionDtPrecision

Category

Category

ChangeReason

ChangeReason

ModyfingPerson

ModyfingPerson

PerfDT

PerfDT


Kolumna WaitListItemHistoryID tabeli WaitListItemHistory

Definicja kolumny WaitListItemHistoryID tabeli WaitListItemHistory

Name

WaitListItemHistoryID

Code

WaitListItemHistoryID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna WaitingListItemID tabeli WaitListItemHistory

Definicja kolumny WaitingListItemID tabeli WaitListItemHistory

Name

WaitingListItemID

Code

WaitingListItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StatusID tabeli WaitListItemHistory

Definicja kolumny StatusID tabeli WaitListItemHistory

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExpectedAdmissionDT tabeli WaitListItemHistory

Definicja kolumny ExpectedAdmissionDT tabeli WaitListItemHistory

Name

ExpectedAdmissionDT

Code

ExpectedAdmissionDT

Data Type

DATE

Mandatory

No

Comment

Planowana data udzielenia swiadczenia


Kolumna ExpectedAdmissionDtPrecision tabeli WaitListItemHistory

Definicja kolumny ExpectedAdmissionDtPrecision tabeli WaitListItemHistory

Name

ExpectedAdmissionDtPrecision

Code

ExpectedAdmissionDtPrecision

Data Type

VARCHAR2(1)

Mandatory

No

Comment

Dokladnosc zaplanowania daty realizacji


Kolumna Category tabeli WaitListItemHistory

Definicja kolumny Category tabeli WaitListItemHistory

Name

Category

Code

Category

Data Type

VARCHAR2(1)

Mandatory

No

Comment

Kryterium medyczne zastosowane przy planowaniu daty realizacji


Kolumna ChangeReason tabeli WaitListItemHistory

Definicja kolumny ChangeReason tabeli WaitListItemHistory

Name

ChangeReason

Code

ChangeReason

Data Type

VARCHAR2(200)

Mandatory

No

Comment

Powód zmiany wpisu na liscie oczekujacych


Kolumna ModyfingPerson tabeli WaitListItemHistory

Definicja kolumny ModyfingPerson tabeli WaitListItemHistory

Name

ModyfingPerson

Code

ModyfingPerson

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna PerfDT tabeli WaitListItemHistory

Definicja kolumny PerfDT tabeli WaitListItemHistory

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

Data wykonania zmiany


Lista kluczy tabeli WaitListItemHistory

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli WaitListItemHistory

Definicja klucza Identifier_1 tabeli WaitListItemHistory

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment